package com.exam.Mapper;

import com.exam.vo.AnswerVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;


@Mapper
public interface AnswerMapper {
    //多返回一个questionId
    @Select("select description, subject, scores, questionId, \"单选题\" as type from single_question " +
            "union select  description, subject, scores, questionId, \"判断题\" as type  from judge_question " +
            "union select  description, subject, scores, questionId, \"填空题\" as type from fill_question " +
            "union select  description, subject, scores, questionId, \"多选题\" as type from multi_question"
            )
    List<AnswerVO> findAll();
}
